Pandas Profiling Report

Dataset info

Number of variables	81
Number of observations	5499
Missing cells	57440 (12.9%)
Duplicate rows	0 (0.0%)
Total size in memory	3.4 MiB
Average record size in memory	648.0 B

Variables types

Numeric	10
Categorical	38
Boolean	17
Date	0
URL	0
Text (Unique)	0
Rejected	16
Unsupported	0

Warnings

`AdvanceAmount` has constant value "0.0"	Rejected
`AdvanceReject(Y/N)` has 368 (6.7%) missing values	Missing
`AmountClaim` has 339 (6.2%) zeros	Zeros
`AOEmailAddress` has a high cardinality: 324 distinct values	Warning
`AOEmailAddress` has 377 (6.9%) missing values	Missing
`AwaitingStatus` has constant value "nan"	Rejected
`CancelledDate` has 5489 (99.8%) missing values	Missing
`Changes_Needed_(Y/N)` has 4555 (82.8%) missing values	Missing
`Comments` has a high cardinality: 348 distinct values	Warning
`Comments` has 4557 (82.9%) missing values	Missing
`ConstructiveTravelFlag` has 368 (6.7%) missing values	Missing
`Corrected_Date` has a high cardinality: 74 distinct values	Warning
`Corrected_Date` has 5375 (97.7%) missing values	Missing
`CurrentVersionCompletedDate` has a high cardinality: 297 distinct values	Warning
`DateofCurrentStatus` has a high cardinality: 303 distinct values	Warning
`DCSSuborganization` has 3511 (63.8%) missing values	Missing
`DepartureDate` has a high cardinality: 462 distinct values	Warning
`DocumentCreateDate` has a high cardinality: 382 distinct values	Warning
`DocumentName` has a high cardinality: 5013 distinct values	Warning
`DTAIDEmailAddress` has 368 (6.7%) missing values	Missing
`Error_Category` has constant value "nan"	Rejected
`ExpensesbyLOA` has 433 (7.9%) zeros	Zeros
`FullName` has a high cardinality: 1154 distinct values	Warning
`ImproperPaymentCorrections` is highly skewed (γ1 = 65.72940543)	Skewed
`ImproperPaymentCorrections` has 5290 (96.2%) zeros	Zeros
`IncludesSPP(Y/N)` has constant value "N"	Rejected
`LastAOApprovedDate` has a high cardinality: 297 distinct values	Warning
`LOA10by20` has a high cardinality: 548 distinct values	Warning
`LOALabel` has a high cardinality: 547 distinct values	Warning
`Location/Destination(firstonly)` has a high cardinality: 498 distinct values	Warning
`Location/Destination(firstonly)` has 529 (9.6%) missing values	Missing
`Month_Rank` is highly correlated with `df_index` (ρ = 0.9899008813)	Rejected
`Overpayments(Debts)*` is highly skewed (γ1 = 22.12386129)	Skewed
`Overpayments(Debts)*` has 5332 (97.0%) zeros	Zeros
`Overpayments_(Debts)` is highly correlated with `Overpayments(Debts)` (ρ = 1)	Rejected
`PNRRecordLocator(allshown)` has a high cardinality: 3267 distinct values	Warning
`PNRRecordLocator(allshown)` has 1729 (31.4%) missing values	Missing
`Reference` has a high cardinality: 111 distinct values	Warning
`Reference` has 5222 (95.0%) missing values	Missing
`ReturnDate` has a high cardinality: 467 distinct values	Warning
`ReviewedVouchers` is highly correlated with `Reviewed_Record` (ρ = 1)	Rejected
`SDN(representativeSDNfordoctype)` has a high cardinality: 4942 distinct values	Warning
`Sent_Date` has 5283 (96.1%) missing values	Missing
`SignedDate` has a high cardinality: 355 distinct values	Warning
`SpecialCircumstancesTripType` has constant value "nan"	Rejected
`SPPReject(Y/N)` has 368 (6.7%) missing values	Missing
`SSN` has a high cardinality: 1077 distinct values	Warning
`SSN` has 368 (6.7%) missing values	Missing
`TANum` has a high cardinality: 4887 distinct values	Warning
`TotalCP-C/CR-CAmount` is highly skewed (γ1 = 70.0678505)	Skewed
`TotalCP-C/CR-CAmount` has 5478 (99.6%) zeros	Zeros
`TotalCP/CRAmount` has 2891 (52.6%) zeros	Zeros
`TotalInputError` is highly correlated with `InputError` (ρ = 1)	Rejected
`TotalMiscellaneous` is highly correlated with `Miscellaneous` (ρ = 1)	Rejected
`TotalMissingInvalidReceiptDocumentation` is highly correlated with `Missing_InvalidReceipt_Documentation` (ρ = 1)	Rejected
`TotalReceiptDoesNotMatchClaim` is highly correlated with `Receiptdoesnotmatchclaim` (ρ = 1)	Rejected
`TotalRegulationUnauthorized` is highly correlated with `Regulation_Unauthorized` (ρ = 1)	Rejected
`TotalReimbursableExpenses` is highly correlated with `AmountClaim` (ρ = 0.9993386598)	Rejected
`TotalTripExpenses` is highly correlated with `TotalReimbursableExpenses` (ρ = 0.9988470133)	Rejected
`Travel_Location` has a high cardinality: 498 distinct values	Warning
`Travel_Location` has 529 (9.6%) missing values	Missing
`TravelerEmailAddress` has a high cardinality: 1152 distinct values	Warning
`TravelerEmailAddress` has 368 (6.7%) missing values	Missing
`TravelerFirstName` has a high cardinality: 616 distinct values	Warning
`TravelerLastName` has a high cardinality: 1005 distinct values	Warning
`TripDescription` has a high cardinality: 3510 distinct values	Warning
`TripDescription` has 1194 (21.7%) missing values	Missing
`TripPurpose` has 166 (3.0%) missing values	Missing
`TripType` has 166 (3.0%) missing values	Missing
`Underpayments(Credits)*` is highly skewed (γ1 = 51.72512377)	Skewed
`Underpayments(Credits)*` has 5428 (98.7%) zeros	Zeros
`Underpayments_(Credits)` is highly correlated with `Underpayments(Credits)` (ρ = 1)	Rejected

Actuals(Y/N)
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	4855
Y	644

Toggle details

Value	Count	Frequency (%)
N	4855	88.3%
Y	644	11.7%

AdvanceAmount
Constant

This variable is constant and should be ignored for analysis

Constant value	0.0

AdvanceReject(Y/N)
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	6.7%
Missing (n)	368

N	5131
(Missing)	368

Toggle details

Common values
Composition

Value	Count	Frequency (%)
N	5131	93.3%
(Missing)	368	6.7%

Max length	3
Mean length	1.133842517
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

Advisory
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5390
1	109

Toggle details

Value	Count	Frequency (%)
0	5390	98.0%
1	109	2.0%

AmountClaim
Numeric

Distinct count	3591
Unique (%)	65.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2016.091331
Minimum	0
Maximum	56739.73
Zeros (%)	6.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	255
Median	904.36
Q3	2097.09
95-th percentile	7696.943
Maximum	56739.73
Range	56739.73
Interquartile range	1842.09

Descriptive statistics

Standard deviation	3804.246035
Coef of variation	1.886941319
Kurtosis	52.56479669
Mean	2016.091331
MAD	1998.847841
Skewness	5.976357566
Sum	11086486.23
Variance	14472287.9
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 1.550000e+00 4.050000e+00 7.425000e+00 9.030000e+00 ... 1.108554e+04 1.551254e+04 2.210496e+04 4.390844e+04 5.673973e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	339	6.2%
91.5	114	2.1%
307.5	52	0.9%
161.5	41	0.7%
176.5	38	0.7%
8.35	37	0.7%
157.5	30	0.5%
211.5	26	0.5%
320	25	0.5%
3.1	25	0.5%
Other values (3581)	4772	86.8%

Minimum 5 values

Value	Count	Frequency (%)
0	339	6.2%
3.1	25	0.5%
5	2	< 0.1%
5.25	1	< 0.1%
6.47	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
56739.73	1	< 0.1%
53760.22	1	< 0.1%
43908.57	1	< 0.1%
43908.31	2	< 0.1%
42330.84	3	0.1%

AOEmailAddress
Categorical

Distinct count	324
Unique (%)	5.9%
Missing (%)	6.9%
Missing (n)	377

MICHAEL.J.MCGONAGLE2.CIV@MAIL.MIL	634
jason.focht@us.af.mil	260
darrell.l.williams58.civ@mail.mil	192
Other values (320)	4036
(Missing)	377

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MICHAEL.J.MCGONAGLE2.CIV@MAIL.MIL	634	11.5%
jason.focht@us.af.mil	260	4.7%
darrell.l.williams58.civ@mail.mil	192	3.5%
john.l.huff8.mil@mail.mil	149	2.7%
michael.a.hansen12.civ@mail.mil	122	2.2%
Vincent.Cassano@me.navy.mil	109	2.0%
john.a.syc.civ@mail.mil	98	1.8%
omar.correa@airtermnorva.navy.mil	96	1.7%
LASHON.R.RUSSELL@NAVY.MIL	95	1.7%
brian.j.muller.civ@mail.mil	91	1.7%
Other values (313)	3276	59.6%
(Missing)	377	6.9%

Max length	39
Mean length	26.17966903
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

AutoKey
Numeric

Distinct count	5499
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	65519.00182
Minimum	58303
Maximum	69795
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	58303
5-th percentile	62778.9
Q1	63878.5
Median	65253
Q3	66627.5
95-th percentile	68831.1
Maximum	69795
Range	11492
Interquartile range	2749

Descriptive statistics

Standard deviation	2006.940967
Coef of variation	0.0306314338
Kurtosis	-0.792993044
Mean	65519.00182
MAD	1667.956168
Skewness	0.3715240928
Sum	360288991
Variance	4027812.045
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[58303. 62526.5 66744.5 67850.5 68917.5 69460.5 69560.5 69710.5 69795. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
65031	1	< 0.1%
67928	1	< 0.1%
67874	1	< 0.1%
65805	1	< 0.1%
65919	1	< 0.1%
67927	1	< 0.1%
65148	1	< 0.1%
66026	1	< 0.1%
64110	1	< 0.1%
65511	1	< 0.1%
Other values (5489)	5489	99.8%

Minimum 5 values

Value	Count	Frequency (%)
58303	1	< 0.1%
58852	1	< 0.1%
58853	1	< 0.1%
58854	1	< 0.1%
58938	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
69795	1	< 0.1%
69794	1	< 0.1%
69793	1	< 0.1%
69792	1	< 0.1%
69791	1	< 0.1%

AwaitingStatus
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

CancelledDate
Categorical

Distinct count	11
Unique (%)	0.2%
Missing (%)	99.8%
Missing (n)	5489

43619	1
8/13/2019	1
2/10/2020	1
Other values (7)	7
(Missing)	5489

Toggle details

Common values
Composition

Value	Count	Frequency (%)
43619	1	< 0.1%
8/13/2019	1	< 0.1%
2/10/2020	1	< 0.1%
11/18/2019	1	< 0.1%
9/13/2019	1	< 0.1%
7/22/2019	1	< 0.1%
7/24/2019	1	< 0.1%
8/15/2019	1	< 0.1%
3/24/2020	1	< 0.1%
1/10/2020	1	< 0.1%
(Missing)	5489	99.8%

Max length	10
Mean length	3.010365521
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

Changes_Needed_(Y/N)
Boolean

Distinct count	3
Unique (%)	0.1%
Missing (%)	82.8%
Missing (n)	4555

No	725
Yes	219
(Missing)	4555

Toggle details

Value	Count	Frequency (%)
No	725	13.2%
Yes	219	4.0%
(Missing)	4555	82.8%

Comments
Categorical

Distinct count	348
Unique (%)	6.3%
Missing (%)	82.9%
Missing (n)	4557

Okay	584
This voucher being audited as it overlaps with TANUM 28IXFD, changed Month-End Date from 5-31-2019 so it will print on the July PPR report. Because this is a TDY from a TDY location the first and last day of this is considered interim travel days and should be paid at full M&IE rate not as 75% travel day. Traveler due additional $28. Per JTR 020303 Table 2-16, Lodging claim for this TDY should be claimed on the per diem screen, lodging retained at the original TDY location is claimed under expenses as Dual Lodging. Unable to correct errors as traveler is no longer assigned to USTRANSCOM. TSgt Patrick Weaver - 20191018	3
Advisory: This voucher was T-entered by Kayla Georgiafandis. The DD 1351-2 attached was printed from DTS after the voucher was created. If the NDEA creates the voucher without being given a signed DD 1351-2 telling them what to claim on the voucher, the Traveler needs to review the voucher and personnally sign it using their CAC. In order for an NDEA to use T-enter (sign the voucher) capability the following rules MUST be followed: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the capability removed. The procedures outlined above and in the NDEA training keeps the NDEA from any pecuniary liability for an improper payment.	2
Other values (344)	353
(Missing)	4557

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Okay	584	10.6%
This voucher being audited as it overlaps with TANUM 28IXFD, changed Month-End Date from 5-31-2019 so it will print on the July PPR report. Because this is a TDY from a TDY location the first and last day of this is considered interim travel days and should be paid at full M&IE rate not as 75% travel day. Traveler due additional $28. Per JTR 020303 Table 2-16, Lodging claim for this TDY should be claimed on the per diem screen, lodging retained at the original TDY location is claimed under expenses as Dual Lodging. Unable to correct errors as traveler is no longer assigned to USTRANSCOM. TSgt Patrick Weaver - 20191018	3	0.1%
Advisory: This voucher was T-entered by Kayla Georgiafandis. The DD 1351-2 attached was printed from DTS after the voucher was created. If the NDEA creates the voucher without being given a signed DD 1351-2 telling them what to claim on the voucher, the Traveler needs to review the voucher and personnally sign it using their CAC. In order for an NDEA to use T-enter (sign the voucher) capability the following rules MUST be followed: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the capability removed. The procedures outlined above and in the NDEA training keeps the NDEA from any pecuniary liability for an improper payment.	2	< 0.1%
Advisory: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it prior to it being completed in DTS. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) This was improperly T-entered by Marrisa Myatt. This is the 3rd month she was found to not be following the Dod FMR Regulations.	2	< 0.1%
This voucher was T-entered by Giselle Murrell. There is no DD 1351-2 submitted by and signed by the traveler attached. Before a Non-DTS Entry Agent (NDEA) can T-ENTER a voucher, the traveler must provide the NDEA with a signed, manually-prepared DD Form 1351-2 telling them what expenses to claim on the voucher. According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the T-enter capability removed. The procedures outlined above, and in the NDEA training, keep the NDEA from any pecuniary liability for an improper payment. Please have traveler provide a completed and signed DD 1351-2 and attach it.	2	< 0.1%
Advisory: Traveler was charged $100 for lodging on the day of arrival but only claimed $90 may be due additional $10 if they choose to amend.	2	< 0.1%
Okay - 12 hrs or less	2	< 0.1%
Advisory: Laundry is covered by the daily incidental paid the traveler and is not a reimbursable item. No change required as it is under $10 and would be written off.	2	< 0.1%
Advisory: Per DoD FMR vol 9 Ch 8 080401G -To receive proper reimbursement, the traveler must report the following information on their travel claim: The amount of the expense in foreign currency; the exchange rate on the day the item was purchased in cash, or, the exchange rate at which the credit card was billed if paid with a credit card; and the bank commission(s) charged for conversion of U.S. dollars to foreign currency. The traveler must show the rates of conversion and the commission(s) charged. If the traveler does not show the conversion rate(s), the activity settling the claim must use an appropriate exchange rate for the date the expense was paid	2	< 0.1%
Advisory: Was traveler's business conducted in Belleville or at Scott AFB? If Scott AFB that should have been the TDY location used, which would require a Non-A to stay off base. Without a Non-A traveler should have been limited to the $105 rate for lodging on base.	2	< 0.1%
Other values (337)	339	6.2%
(Missing)	4557	82.9%

Max length	3409
Mean length	36.08346972
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

ConstructiveTravelFlag
Boolean

Distinct count	3
Unique (%)	0.1%
Missing (%)	6.7%
Missing (n)	368

N	5089
Y	42
(Missing)	368

Toggle details

Value	Count	Frequency (%)
N	5089	92.5%
Y	42	0.8%
(Missing)	368	6.7%

Corrected_Date
Categorical

Distinct count	74
Unique (%)	1.3%
Missing (%)	97.7%
Missing (n)	5375

10/18/19	20
11/4/19	5
4/27/20	4
Other values (70)	95
(Missing)	5375

Toggle details

Common values
Composition

Value	Count	Frequency (%)
10/18/19	20	0.4%
11/4/19	5	0.1%
4/27/20	4	0.1%
3/13/20	3	0.1%
3/11/20	3	0.1%
12/10/19	3	0.1%
1/22/20	3	0.1%
4/20/20	3	0.1%
9/18/19	3	0.1%
8/16/19	2	< 0.1%
Other values (63)	75	1.4%
(Missing)	5375	97.7%

Max length	8
Mean length	3.093289689
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

CorrectedVouchers
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5376
1	123

Toggle details

Value	Count	Frequency (%)
0	5376	97.8%
1	123	2.2%

CurrentStatus
Categorical

Distinct count	19
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

ARCHIVE IMAGE ACCEPT	2256
ARCHIVE ACCEPTED	2208
OBLIG SUBMITTED	260
Other values (16)	775

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ARCHIVE IMAGE ACCEPT	2256	41.0%
ARCHIVE ACCEPTED	2208	40.2%
OBLIG SUBMITTED	260	4.7%
POS ACK RECEIVED	234	4.3%
VOUCHER SUBMITTED	211	3.8%
ARCHIVE SUBMITTED	127	2.3%
REJECT	54	1.0%
DUE PROCESS SERVED	44	0.8%
ARCHIVE IMAGE SUBMIT	33	0.6%
PAID	22	0.4%
Other values (9)	50	0.9%

Max length	20
Mean length	17.54373522
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

CurrentVersionCompletedDate
Categorical

Distinct count	297
Unique (%)	5.4%
Missing (%)	0.2%
Missing (n)	10

12/2/19	83
7/3/19	62
2/10/20	55
Other values (293)	5289

Toggle details

Common values
Composition

Value	Count	Frequency (%)
12/2/19	83	1.5%
7/3/19	62	1.1%
2/10/20	55	1.0%
12/4/19	53	1.0%
7/22/19	45	0.8%
9/23/19	45	0.8%
12/18/19	45	0.8%
12/3/19	45	0.8%
2/3/20	44	0.8%
9/16/19	43	0.8%
Other values (286)	4969	90.4%

Max length	8
Mean length	6.98108747
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

DateofCurrentStatus
Categorical

Distinct count	303
Unique (%)	5.5%
Missing (%)	0.0%
Missing (n)	0

12/31/19	102
12/28/19	100
12/30/19	99
Other values (300)	5198

Toggle details

Common values
Composition

Value	Count	Frequency (%)
12/31/19	102	1.9%
12/28/19	100	1.8%
12/30/19	99	1.8%
12/29/19	92	1.7%
2/20/20	86	1.6%
2/22/20	81	1.5%
11/27/19	78	1.4%
1/1/20	73	1.3%
10/9/19	69	1.3%
10/12/19	67	1.2%
Other values (293)	4652	84.6%

Max length	8
Mean length	7.054737225
Min length	6
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

DCSSuborganization
Categorical

Distinct count	19
Unique (%)	0.3%
Missing (%)	63.8%
Missing (n)	3511

BA	364
RS	251
SG	175
Other values (15)	1198
(Missing)	3511

Toggle details

Common values
Composition

Value	Count	Frequency (%)
BA	364	6.6%
RS	251	4.6%
SG	175	3.2%
BH	160	2.9%
JA	157	2.9%
LV	131	2.4%
NF	123	2.2%
TV	119	2.2%
SN	98	1.8%
YO	75	1.4%
Other values (8)	335	6.1%
(Missing)	3511	63.8%

Max length	3
Mean length	2.638479724
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

DepartureDate
Categorical

Distinct count	462
Unique (%)	8.4%
Missing (%)	0.0%
Missing (n)	0

9/16/19	59
10/1/19	59
12/9/19	57
Other values (459)	5324

Toggle details

Common values
Composition

Value	Count	Frequency (%)
9/16/19	59	1.1%
10/1/19	59	1.1%
12/9/19	57	1.0%
2/24/20	51	0.9%
11/12/19	51	0.9%
5/28/19	49	0.9%
2/10/20	47	0.9%
9/22/19	46	0.8%
10/7/19	46	0.8%
8/12/19	46	0.8%
Other values (452)	4988	90.7%

Max length	8
Mean length	6.939443535
Min length	6
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

df_index
Numeric

Distinct count	5499
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3451.171849
Minimum	0
Maximum	7132
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	377.9
Q1	1650.5
Median	3352
Q3	5241.5
95-th percentile	6741.1
Maximum	7132
Range	7132
Interquartile range	3591

Descriptive statistics

Standard deviation	2062.893212
Coef of variation	0.5977370302
Kurtosis	-1.219564481
Mean	3451.171849
MAD	1794.976145
Skewness	0.1018863934
Sum	18977994
Variance	4255528.404
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 239. 280.5 2964.5 3028.5 ... 3985.5 4086.5 5633.5 5732.5 7132. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2047	1	< 0.1%
4691	1	< 0.1%
2632	1	< 0.1%
585	1	< 0.1%
6730	1	< 0.1%
2636	1	< 0.1%
6734	1	< 0.1%
2640	1	< 0.1%
593	1	< 0.1%
6738	1	< 0.1%
Other values (5489)	5489	99.8%

Minimum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
7132	1	< 0.1%
7131	1	< 0.1%
7130	1	< 0.1%
7129	1	< 0.1%
7128	1	< 0.1%

Directorate
Categorical

Distinct count	14
Unique (%)	0.3%
Missing (%)	0.1%
Missing (n)	4

TCJ3DCS	1988
JECC	1238
TCJ3	576
Other values (10)	1693

Toggle details

Common values
Composition

Value	Count	Frequency (%)
TCJ3DCS	1988	36.2%
JECC	1238	22.5%
TCJ3	576	10.5%
TCJ5	533	9.7%
TCCC	399	7.3%
TCSG	162	2.9%
TCAQ	145	2.6%
TCJ6	141	2.6%
TCJ8	139	2.5%
TCJ1	84	1.5%
Other values (3)	90	1.6%

Max length	7
Mean length	5.083833424
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

DocumentCreateDate
Categorical

Distinct count	382
Unique (%)	6.9%
Missing (%)	0.0%
Missing (n)	0

11/25/19	62
2/3/20	54
3/9/20	54
Other values (379)	5329

Toggle details

Common values
Composition

Value	Count	Frequency (%)
11/25/19	62	1.1%
2/3/20	54	1.0%
3/9/20	54	1.0%
9/30/19	53	1.0%
12/18/19	52	0.9%
3/2/20	47	0.9%
1/21/20	46	0.8%
9/16/19	45	0.8%
11/26/19	45	0.8%
11/22/19	43	0.8%
Other values (372)	4998	90.9%

Max length	8
Mean length	6.999818149
Min length	6
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

DocumentName
Categorical

Distinct count	5013
Unique (%)	91.2%
Missing (%)	0.0%
Missing (n)	0

SLPOPEARMYAIR081619_V01	6
SLSTUTTGARTDE111219_V01	6
SLROBINSAFBGA080819_V01	6
Other values (5010)	5481

Toggle details

Common values
Composition

Value	Count	Frequency (%)
SLPOPEARMYAIR081619_V01	6	0.1%
SLSTUTTGARTDE111219_V01	6	0.1%
SLROBINSAFBGA080819_V01	6	0.1%
SLWASHINGTOND031120_V01	5	0.1%
ESNORFOLKVA091519_V03	5	0.1%
SLSHAWAFBSC082219_V01	5	0.1%
SLFAIRCHILDAF092419_V01	5	0.1%
SLNORFOLKNAVA012120_V01	5	0.1%
SLWASHINGTOND071719_V01	5	0.1%
SLAUSTINTX020620_V01	5	0.1%
Other values (5003)	5446	99.0%

Max length	26
Mean length	22.47663211
Min length	12
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

DocumentType
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

VCH	5333
LVCH	166

Toggle details

Common values
Composition

Value	Count	Frequency (%)
VCH	5333	97.0%
LVCH	166	3.0%

Max length	4
Mean length	3.030187307
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

DTAIDEmailAddress
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	6.7%
Missing (n)	368

transcom.scott.tcj8.mbx.dts-rejects@mail.mil	5131
(Missing)	368

Toggle details

Common values
Composition

Value	Count	Frequency (%)
transcom.scott.tcj8.mbx.dts-rejects@mail.mil	5131	93.3%
(Missing)	368	6.7%

Max length	44
Mean length	41.25622841
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

Error_Category
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

ExpensesbyLOA
Numeric

Distinct count	3766
Unique (%)	68.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1629.298071
Minimum	0
Maximum	56739.73
Zeros (%)	7.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	225.35
Median	775.39
Q3	1767.6
95-th percentile	5694.408
Maximum	56739.73
Range	56739.73
Interquartile range	1542.25

Descriptive statistics

Standard deviation	3198.752153
Coef of variation	1.96327008
Kurtosis	80.50969153
Mean	1629.298071
MAD	1558.213834
Skewness	7.311093677
Sum	8959510.09
Variance	10232015.34
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 1.5500000e+00 4.0500000e+00 7.4250000e+00 9.0300000e+00 ... 5.8580700e+03 8.0538000e+03 1.2559835e+04 2.4249640e+04 5.6739730e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	433	7.9%
91.5	121	2.2%
307.5	51	0.9%
161.5	42	0.8%
176.5	41	0.7%
8.35	37	0.7%
157.5	29	0.5%
211.5	26	0.5%
3.1	26	0.5%
320	25	0.5%
Other values (3756)	4668	84.9%

Minimum 5 values

Value	Count	Frequency (%)
0	433	7.9%
3.1	26	0.5%
5	2	< 0.1%
5.25	1	< 0.1%
6.47	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
56739.73	1	< 0.1%
53760.22	1	< 0.1%
43908.31	2	< 0.1%
42330.84	2	< 0.1%
41483.87	2	< 0.1%

FinancialReject(Y/N)
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	5445
Y	54

Toggle details

Value	Count	Frequency (%)
N	5445	99.0%
Y	54	1.0%

ForeignTravelFlag
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	3981
Y	1518

Toggle details

Value	Count	Frequency (%)
N	3981	72.4%
Y	1518	27.6%

FullName
Categorical

Distinct count	1154
Unique (%)	21.0%
Missing (%)	0.0%
Missing (n)	0

JAMES SHEPARD	38
STEPHEN LYONS	37
JOSEPH REICHERT	32
Other values (1151)	5392

Toggle details

Common values
Composition

Value	Count	Frequency (%)
JAMES SHEPARD	38	0.7%
STEPHEN LYONS	37	0.7%
JOSEPH REICHERT	32	0.6%
ANDREA GONZALES	31	0.6%
DONALD ABSHER	31	0.6%
SHAWN BEDARD	29	0.5%
TRACEY TURNER	29	0.5%
HORACE TAYLOR	28	0.5%
JASON FRANCE	27	0.5%
ANDREW KRUCZYK	27	0.5%
Other values (1144)	5190	94.4%

Max length	25
Mean length	13.67612293
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

ImproperPaymentCorrections
Numeric

Distinct count	58
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	236.2027641
Minimum	0
Maximum	332306
Zeros (%)	96.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	332306
Range	332306
Interquartile range	0

Descriptive statistics

Standard deviation	4666.375408
Coef of variation	19.75580356
Kurtosis	4666.80792
Mean	236.2027641
MAD	461.6530748
Skewness	65.72940543
Sum	1298879
Variance	21775059.45
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 7.500000e+00 5.700000e+01 5.900000e+01 9.800000e+01 2.265000e+02 1.711525e+05 3.323060e+05], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	5290	96.2%
9999	96	1.7%
58	16	0.3%
1	8	0.1%
94	4	0.1%
7	4	0.1%
4	4	0.1%
48	4	0.1%
5	3	0.1%
162	3	0.1%
Other values (48)	67	1.2%

Minimum 5 values

Value	Count	Frequency (%)
0	5290	96.2%
1	8	0.1%
2	3	0.1%
4	4	0.1%
5	3	0.1%

Maximum 5 values

Value	Count	Frequency (%)
332306	1	< 0.1%
9999	96	1.7%
253	1	< 0.1%
200	1	< 0.1%
194	1	< 0.1%

ImproperPayments
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5280
1	219

Toggle details

Value	Count	Frequency (%)
0	5280	96.0%
1	219	4.0%

IncludesSPP(Y/N)
Constant

This variable is constant and should be ignored for analysis

Constant value	N

InputError
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5456
1	43

Toggle details

Value	Count	Frequency (%)
0	5456	99.2%
1	43	0.8%

LastAOApprovedDate
Categorical

Distinct count	297
Unique (%)	5.4%
Missing (%)	0.2%
Missing (n)	10

12/2/19	83
7/3/19	62
2/10/20	55
Other values (293)	5289

Toggle details

Common values
Composition

Value	Count	Frequency (%)
12/2/19	83	1.5%
7/3/19	62	1.1%
2/10/20	55	1.0%
12/4/19	53	1.0%
7/22/19	45	0.8%
9/23/19	45	0.8%
12/18/19	45	0.8%
12/3/19	45	0.8%
2/3/20	44	0.8%
9/16/19	43	0.8%
Other values (286)	4969	90.4%

Max length	8
Mean length	6.98108747
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

LOA10by20
Categorical

Distinct count	548
Unique (%)	10.0%
Missing (%)	0.0%
Missing (n)	0

387700^97^^X^4930^FD60^6J^0^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	209
387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	202
387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	172
Other values (545)	4916

Toggle details

Common values
Composition

Value	Count	Frequency (%)
387700^97^^X^4930^FD60^6J^0^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	209	3.8%
387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	202	3.7%
387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	172	3.1%
387700^97^^X^4930^FD60^6J^9^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	144	2.6%
387700^97^^X^4930^FD60^6J^0^70^FB^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	122	2.2%
387700^97^^X^4930^FD60^6J^9^70^FB^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	102	1.9%
387700^97^^X^4930^FD60^6J^0^70^FC^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	89	1.6%
387700^97^^X^4930^FD60^6J^0^70^D3^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	88	1.6%
387700^57^^9^3400^^30^9^70^JE^G3JE40^02^^^^^40924^^^387700^^^21400F^^^^^	85	1.5%
387700^97^^X^4930^FD60^6J^0^70^FA^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^	81	1.5%
Other values (538)	4205	76.5%

Max length	103
Mean length	78.5766503
Min length	64
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

LOALabel
Categorical

Distinct count	547
Unique (%)	9.9%
Missing (%)	0.0%
Missing (n)	0

20 DCS BA MSPT	209
20 CMDSEC MSPT	202
19 CMDSEC MSPT	172
Other values (544)	4916

Toggle details

Common values
Composition

Value	Count	Frequency (%)
20 DCS BA MSPT	209	3.8%
20 CMDSEC MSPT	202	3.7%
19 CMDSEC MSPT	172	3.1%
19 DCS BA MSPT	144	2.6%
20 DCS RS MSPT	122	2.2%
19 DCS RS MSPT	102	1.9%
20 DCS SG MSPT	89	1.6%
20 DCS JA MSPT	88	1.6%
19 JR_JPSE	85	1.5%
20 DCS BH MSPT	81	1.5%
Other values (537)	4205	76.5%

Max length	15
Mean length	12.88343335
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

Location/Destination(firstonly)
Categorical

Distinct count	498
Unique (%)	9.1%
Missing (%)	9.6%
Missing (n)	529

NORFOLK NAVAL STATION,VA	289
WASHINGTON,DC	228
MACDILL AFB,FL	124
Other values (494)	4329
(Missing)	529

Toggle details

Common values
Composition

Value	Count	Frequency (%)
NORFOLK NAVAL STATION,VA	289	5.3%
WASHINGTON,DC	228	4.1%
MACDILL AFB,FL	124	2.3%
SCOTT AFB,IL	121	2.2%
PENTAGON,VA	106	1.9%
MEMPHIS,TN	106	1.9%
RAMSTEIN AB,DEU	97	1.8%
SIGONELLA NAS,ITA	93	1.7%
MILITARY BASES NOT IN KUWAIT CITY,KWT	82	1.5%
SAN ANTONIO,TX	79	1.4%
Other values (487)	3645	66.3%
(Missing)	529	9.6%

Max length	47
Mean length	14.78868885
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Miscellaneous
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5498
1	1

Toggle details

Value	Count	Frequency (%)
0	5498	> 99.9%
1	1	< 0.1%

Missing_InvalidReceipt_Documentation
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5408
1	91

Toggle details

Value	Count	Frequency (%)
0	5408	98.3%
1	91	1.7%

Month_End
Categorical

Distinct count	12
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0

9/30/19	645
12/31/19	612
8/30/19	586
Other values (9)	3656

Toggle details

Common values
Composition

Value	Count	Frequency (%)
9/30/19	645	11.7%
12/31/19	612	11.1%
8/30/19	586	10.7%
10/31/19	583	10.6%
2/29/20	555	10.1%
6/30/19	534	9.7%
7/31/19	532	9.7%
3/31/20	516	9.4%
11/30/19	380	6.9%
1/31/20	368	6.7%
Other values (2)	188	3.4%

Max length	8
Mean length	7.286415712
Min length	7
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

Month_Rank
Highly correlated

This variable is highly correlated with df_index and should be ignored for analysis

Correlation	0.9899008813

MultipleLOAs(Y/N)
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	4826
Y	673

Toggle details

Value	Count	Frequency (%)
N	4826	87.8%
Y	673	12.2%

Non-contractFareFlag
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	5117
Y	382

Toggle details

Value	Count	Frequency (%)
N	5117	93.1%
Y	382	6.9%

Organization/Suborganization
Categorical

Distinct count	32
Unique (%)	0.6%
Missing (%)	0.0%
Missing (n)	0

DJ60TCJECC_JPSE	918
DJ60TCJ5	533
DJ60TCJ3	433
Other values (29)	3615

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DJ60TCJECC_JPSE	918	16.7%
DJ60TCJ5	533	9.7%
DJ60TCJ3	433	7.9%
DJ60TCCC	400	7.3%
DJ60TCJ3DCSBA	364	6.6%
DJ60TCJECC	321	5.8%
DJ60TCJ3DCSRS	251	4.6%
DJ60TCJ3DCSSG	175	3.2%
DJ60TCSG	162	2.9%
DJ60TCJ3DCSBH	160	2.9%
Other values (22)	1782	32.4%

Max length	15
Mean length	11.11929442
Min length	8
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Overpayments(Debts)*
Numeric

Distinct count	162
Unique (%)	2.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	17.21950173
Minimum	0
Maximum	6823.82
Zeros (%)	97.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	6823.82
Range	6823.82
Interquartile range	0

Descriptive statistics

Standard deviation	210.0849428
Coef of variation	12.20040778
Kurtosis	589.6229387
Mean	17.21950173
MAD	33.4107544
Skewness	22.12386129
Sum	94690.04
Variance	44135.68318
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000e+00 3.80500e+00 9.67550e+01 3.29650e+02 7.04350e+02 1.77073e+03 6.82382e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	5332	97.0%
55	2	< 0.1%
558	2	< 0.1%
504	2	< 0.1%
30.5	2	< 0.1%
220.6	2	< 0.1%
28	2	< 0.1%
26.94	1	< 0.1%
32.78	1	< 0.1%
376	1	< 0.1%
Other values (152)	152	2.8%

Minimum 5 values

Value	Count	Frequency (%)
0	5332	97.0%
7.61	1	< 0.1%
8	1	< 0.1%
8.35	1	< 0.1%
11	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
6823.82	1	< 0.1%
6776.5	1	< 0.1%
5407.5	1	< 0.1%
4564.65	1	< 0.1%
4472.54	1	< 0.1%

Overpayments_(Debts)*
Highly correlated

This variable is highly correlated with Overpayments(Debts)* and should be ignored for analysis

Correlation	1

PNRRecordLocator(allshown)
Categorical

Distinct count	3267
Unique (%)	59.4%
Missing (%)	31.4%
Missing (n)	1729

QXRTCZ	10
MU7XPH	8
UPOMOM	8
Other values (3263)	3744
(Missing)	1729

Toggle details

Common values
Composition

Value	Count	Frequency (%)
QXRTCZ	10	0.2%
MU7XPH	8	0.1%
UPOMOM	8	0.1%
XHAYAN	6	0.1%
2P32PJ OFOJ6S	6	0.1%
NPN5FB	6	0.1%
NCHNGM	5	0.1%
EQWCXJ	5	0.1%
OLLF6J	5	0.1%
2MVC3M	4	0.1%
Other values (3256)	3707	67.4%
(Missing)	1729	31.4%

Max length	20
Mean length	5.330423713
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

Receiptdoesnotmatchclaim
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5429
1	70

Toggle details

Value	Count	Frequency (%)
0	5429	98.7%
1	70	1.3%

Reference
Categorical

Distinct count	111
Unique (%)	2.0%
Missing (%)	95.0%
Missing (n)	5222

80NF	52
RS	16
FX/BWI	10
Other values (107)	199
(Missing)	5222

Toggle details

Common values
Composition

Value	Count	Frequency (%)
80NF	52	0.9%
RS	16	0.3%
FX/BWI	10	0.2%
WP	10	0.2%
RD/NE	8	0.1%
80/NF	7	0.1%
BA3	6	0.1%
FLY NE	6	0.1%
BA10/11	6	0.1%
FLY 12/15/82	6	0.1%
Other values (100)	150	2.7%
(Missing)	5222	95.0%

Max length	30
Mean length	3.311329333
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

Regulation_Unauthorized
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	5389
1	110

Toggle details

Value	Count	Frequency (%)
0	5389	98.0%
1	110	2.0%

ReturnDate
Categorical

Distinct count	467
Unique (%)	8.5%
Missing (%)	0.0%
Missing (n)	0

2/1/20	60
9/20/19	58
9/27/19	58
Other values (464)	5323

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2/1/20	60	1.1%
9/20/19	58	1.1%
9/27/19	58	1.1%
12/13/19	57	1.0%
6/15/19	57	1.0%
11/22/19	56	1.0%
1/31/20	55	1.0%
3/14/20	53	1.0%
10/30/19	53	1.0%
9/30/19	48	0.9%
Other values (457)	4944	89.9%

Max length	8
Mean length	7.013456992
Min length	6
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

Reviewed_Record
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	4556
1	943

Toggle details

Value	Count	Frequency (%)
0	4556	82.9%
1	943	17.1%

ReviewedVouchers
Highly correlated

This variable is highly correlated with Reviewed_Record and should be ignored for analysis

Correlation	1

SDN(representativeSDNfordoctype)
Categorical

Distinct count	4942
Unique (%)	89.9%
Missing (%)	0.5%
Missing (n)	28

2CT6YJ TD	10
2CKT31 TD	6
2CWX4L TD	6
Other values (4938)	5449
(Missing)	28

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2CT6YJ TD	10	0.2%
2CKT31 TD	6	0.1%
2CWX4L TD	6	0.1%
26UZR4 TD	6	0.1%
2BBQ9U	5	0.1%
2C7V91 TD	5	0.1%
2A38PA TD	5	0.1%
2BBQ9U TD	5	0.1%
2D49YM TD	4	0.1%
2CUTTU TD	4	0.1%
Other values (4931)	5415	98.5%
(Missing)	28	0.5%

Max length	19
Mean length	9.962720495
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

Sent_Date
Categorical

Distinct count	15
Unique (%)	0.3%
Missing (%)	96.1%
Missing (n)	5283

8/21/19	43
10/31/19	41
12/5/19	34
Other values (11)	98
(Missing)	5283

Toggle details

Common values
Composition

Value	Count	Frequency (%)
8/21/19	43	0.8%
10/31/19	41	0.7%
12/5/19	34	0.6%
5/4/20	25	0.5%
7/16/19	18	0.3%
3/10/20	16	0.3%
7/17/19	8	0.1%
5/12/20	7	0.1%
2/21/20	7	0.1%
11/4/19	7	0.1%
Other values (4)	10	0.2%
(Missing)	5283	96.1%

Max length	8
Mean length	3.160029096
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

SignedDate
Categorical

Distinct count	355
Unique (%)	6.5%
Missing (%)	< 0.1%
Missing (n)	1

11/25/19	60
9/30/19	56
9/9/19	46
Other values (351)	5336

Toggle details

Common values
Composition

Value	Count	Frequency (%)
11/25/19	60	1.1%
9/30/19	56	1.0%
9/9/19	46	0.8%
11/26/19	46	0.8%
8/20/19	44	0.8%
3/9/20	43	0.8%
12/18/19	42	0.8%
1/21/20	41	0.7%
2/3/20	41	0.7%
10/15/19	41	0.7%
Other values (344)	5038	91.6%

Max length	8
Mean length	6.994544463
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

SpecialCircumstancesTripType
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

SPPReject(Y/N)
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	6.7%
Missing (n)	368

N	5131
(Missing)	368

Toggle details

Common values
Composition

Value	Count	Frequency (%)
N	5131	93.3%
(Missing)	368	6.7%

Max length	3
Mean length	1.133842517
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

SSN
Categorical

Distinct count	1077
Unique (%)	19.6%
Missing (%)	6.7%
Missing (n)	368

*****6633	37
*****3312	35
*****887R	31
Other values (1073)	5028
(Missing)	368

Toggle details

Common values
Composition

Value	Count	Frequency (%)
*****6633	37	0.7%
*****3312	35	0.6%
*****887R	31	0.6%
*****3829	28	0.5%
*****2061	28	0.5%
*****9772	27	0.5%
*****2662	26	0.5%
*****0507	26	0.5%
*****8714	26	0.5%
*****7831	26	0.5%
Other values (1066)	4841	88.0%
(Missing)	368	6.7%

Max length	9
Mean length	8.59847245
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

T-EnteredFlag
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	5419
Y	80

Toggle details

Value	Count	Frequency (%)
N	5419	98.5%
Y	80	1.5%

TANum
Categorical

Distinct count	4887
Unique (%)	88.9%
Missing (%)	0.0%
Missing (n)	0

2BBQ9U	10
2CT6YJ	10
2747I7	8
Other values (4884)	5471

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2BBQ9U	10	0.2%
2CT6YJ	10	0.2%
2747I7	8	0.1%
2CKT31	6	0.1%
26XOI2	6	0.1%
26UZR4	6	0.1%
2CWX4L	6	0.1%
2CYM1U	6	0.1%
2C7V91	5	0.1%
2CQE7V	5	0.1%
Other values (4877)	5431	98.8%

Max length	6
Mean length	6
Min length	6
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

TotalCP-C/CR-CAmount
Numeric

Distinct count	19
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.068894344
Minimum	0
Maximum	13278.15
Zeros (%)	99.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	13278.15
Range	13278.15
Interquartile range	0

Descriptive statistics

Standard deviation	182.6894517
Coef of variation	44.89904043
Kurtosis	5074.461029
Mean	4.068894344
MAD	8.106711482
Skewness	70.0678505
Sum	22374.85
Variance	33375.43576
Memory size	43.1 KiB

Histogram with fixed size bins (bins=19)

Histogram with variable size bins (bins=[0.000000e+00 4.175000e+00 6.432000e+02 1.327815e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	5478	99.6%
457.4	2	< 0.1%
212.8	2	< 0.1%
8.35	2	< 0.1%
623.6	1	< 0.1%
1949	1	< 0.1%
497.6	1	< 0.1%
426.5	1	< 0.1%
278.8	1	< 0.1%
494.28	1	< 0.1%
Other values (9)	9	0.2%

Minimum 5 values

Value	Count	Frequency (%)
0	5478	99.6%
8.35	2	< 0.1%
32.02	1	< 0.1%
212.8	2	< 0.1%
220.6	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
13278.15	1	< 0.1%
1949	1	< 0.1%
662.8	1	< 0.1%
623.6	1	< 0.1%
575.3	1	< 0.1%

TotalCP/CRAmount
Numeric

Distinct count	1153
Unique (%)	21.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	349.6803673
Minimum	0
Maximum	5218.05
Zeros (%)	52.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	499.8
95-th percentile	1397.451
Maximum	5218.05
Range	5218.05
Interquartile range	499.8

Descriptive statistics

Standard deviation	576.8844909
Coef of variation	1.649748012
Kurtosis	13.74087923
Mean	349.6803673
MAD	390.8086792
Skewness	3.048717964
Sum	1922892.34
Variance	332795.7159
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 3.115000e+00 1.008000e+02 1.118500e+02 2.121000e+02 ... 1.597980e+03 1.601980e+03 2.071640e+03 2.800665e+03 5.218050e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	2891	52.6%
220.6	68	1.2%
280.6	50	0.9%
212.8	48	0.9%
212.6	37	0.7%
278.6	36	0.7%
658.6	30	0.5%
278.8	30	0.5%
706.6	23	0.4%
1348.61	21	0.4%
Other values (1143)	2265	41.2%

Minimum 5 values

Value	Count	Frequency (%)
0	2891	52.6%
6.23	1	< 0.1%
8.35	1	< 0.1%
81.3	2	< 0.1%
83.3	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
5218.05	2	< 0.1%
5104.99	2	< 0.1%
4885.28	2	< 0.1%
4788.33	1	< 0.1%
4458.95	1	< 0.1%

TotalDaysTDY
Numeric

Distinct count	115
Unique (%)	2.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.534097109
Minimum	1
Maximum	382
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	4
Q3	7
95-th percentile	37.1
Maximum	382
Range	381
Interquartile range	5

Descriptive statistics

Standard deviation	22.89717298
Coef of variation	2.401608954
Kurtosis	106.6839831
Mean	9.534097109
MAD	9.598986554
Skewness	8.746903959
Sum	52428
Variance	524.2805305
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 5.5 ... 69.5 72. 94. 147.5 382. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	1290	23.5%
3	769	14.0%
4	540	9.8%
1	532	9.7%
5	480	8.7%
6	341	6.2%
7	174	3.2%
8	161	2.9%
13	100	1.8%
9	95	1.7%
Other values (105)	1017	18.5%

Minimum 5 values

Value	Count	Frequency (%)
1	532	9.7%
2	1290	23.5%
3	769	14.0%
4	540	9.8%
5	480	8.7%

Maximum 5 values

Value	Count	Frequency (%)
382	4	0.1%
354	2	< 0.1%
282	6	0.1%
271	1	< 0.1%
262	2	< 0.1%

TotalInputError
Highly correlated

This variable is highly correlated with InputError and should be ignored for analysis

Correlation	1

TotalMiscellaneous
Highly correlated

This variable is highly correlated with Miscellaneous and should be ignored for analysis

Correlation	1

TotalMissingInvalidReceiptDocumentation
Highly correlated

This variable is highly correlated with Missing_InvalidReceipt_Documentation and should be ignored for analysis

Correlation	1

TotalReceiptDoesNotMatchClaim
Highly correlated

This variable is highly correlated with Receiptdoesnotmatchclaim and should be ignored for analysis

Correlation	1

TotalRegulationUnauthorized
Highly correlated

This variable is highly correlated with Regulation_Unauthorized and should be ignored for analysis

Correlation	1

TotalReimbursableExpenses
Highly correlated

This variable is highly correlated with AmountClaim and should be ignored for analysis

Correlation	0.9993386598

TotalTripExpenses
Highly correlated

This variable is highly correlated with TotalReimbursableExpenses and should be ignored for analysis

Correlation	0.9988470133

Travel_Location
Categorical

Distinct count	498
Unique (%)	9.1%
Missing (%)	9.6%
Missing (n)	529

NORFOLK NAVAL STATION,VA	289
WASHINGTON,DC	228
MACDILL AFB,FL	124
Other values (494)	4329
(Missing)	529

Toggle details

Common values
Composition

Value	Count	Frequency (%)
NORFOLK NAVAL STATION,VA	289	5.3%
WASHINGTON,DC	228	4.1%
MACDILL AFB,FL	124	2.3%
SCOTT AFB,IL	121	2.2%
PENTAGON,VA	106	1.9%
MEMPHIS,TN	106	1.9%
RAMSTEIN AB,DEU	97	1.8%
SIGONELLA NAS,ITA	93	1.7%
MILITARY BASES NOT IN KUWAIT CITY,KWT	82	1.5%
SAN ANTONIO,TX	79	1.4%
Other values (487)	3645	66.3%
(Missing)	529	9.6%

Max length	47
Mean length	14.78868885
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

TravelerEmailAddress
Categorical

Distinct count	1152
Unique (%)	20.9%
Missing (%)	6.7%
Missing (n)	368

james.e.shepard22.mil@mail.mil	73
donald.b.absher.mil@mail.mil	31
kayla.m.georgiafandis.mil@mail.mil	28
Other values (1148)	4999
(Missing)	368

Toggle details

Common values
Composition

Value	Count	Frequency (%)
james.e.shepard22.mil@mail.mil	73	1.3%
donald.b.absher.mil@mail.mil	31	0.6%
kayla.m.georgiafandis.mil@mail.mil	28	0.5%
JOSEPH.REICHERT@US.AF.MIL	28	0.5%
shawn.m.bedard.mil@mail.mil	27	0.5%
stewart.harrison@me.navy.mil	26	0.5%
tracey.turner.3@us.af.mil	26	0.5%
ANDREA.GONZALES.5@US.AF.MIL	26	0.5%
horace.e.taylor13.mil@mail.mil	26	0.5%
andrew.kruczyk@us.af.mil	25	0.5%
Other values (1141)	4815	87.6%
(Missing)	368	6.7%

Max length	55
Mean length	25.74777232
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

TravelerFirstName
Categorical

Distinct count	616
Unique (%)	11.2%
Missing (%)	0.0%
Missing (n)	0

CHRISTOPHER	122
JAMES	120
MATTHEW	98
Other values (613)	5159

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CHRISTOPHER	122	2.2%
JAMES	120	2.2%
MATTHEW	98	1.8%
JOHN	93	1.7%
DAVID	92	1.7%
MICHAEL	90	1.6%
ROBERT	85	1.5%
ANDREW	74	1.3%
WILLIAM	73	1.3%
RICHARD	70	1.3%
Other values (606)	4582	83.3%

Max length	15
Mean length	6.142389525
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

TravelerLastName
Categorical

Distinct count	1005
Unique (%)	18.3%
Missing (%)	0.0%
Missing (n)	0

JOHNSON	57
JONES	47
TURNER	45
Other values (1002)	5350

Toggle details

Common values
Composition

Value	Count	Frequency (%)
JOHNSON	57	1.0%
JONES	47	0.9%
TURNER	45	0.8%
WILLIAMS	40	0.7%
Shepard	38	0.7%
LYONS	37	0.7%
SMITH	37	0.7%
REICHERT	32	0.6%
ABSHER	31	0.6%
GONZALES	31	0.6%
Other values (995)	5104	92.8%

Max length	18
Mean length	6.533733406
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

TripDescription
Categorical

Distinct count	3510
Unique (%)	63.8%
Missing (%)	21.7%
Missing (n)	1194

DELIVERY OF CLASSIFED COURIER MATERIAL	28
Deliver DCS material	16
Delivery of classified material.	14
Other values (3506)	4247
(Missing)	1194

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DELIVERY OF CLASSIFED COURIER MATERIAL	28	0.5%
Deliver DCS material	16	0.3%
Delivery of classified material.	14	0.3%
Courier duties; escort DCS material	13	0.2%
Delivery of DCS Material	11	0.2%
TDY	10	0.2%
DoD Courier Mission.	9	0.2%
Delivering DCS material	8	0.1%
Delivery of classified courier material.	8	0.1%
Attending 42A Advance Leader Course at Fort Jackson South Carolina. Will also be taking leave after completing ALC.PNR Locator:UPOMOM	8	0.1%
Other values (3499)	4180	76.0%
(Missing)	1194	21.7%

Max length	1458
Mean length	44.65048191
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

TripPurpose
Categorical

Distinct count	13
Unique (%)	0.2%
Missing (%)	3.0%
Missing (n)	166

MISSION - OPERATIONAL	2999
TRAINING	1258
CONFERENCE- NON-TRAINING	442
Other values (9)	634

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MISSION - OPERATIONAL	2999	54.5%
TRAINING	1258	22.9%
CONFERENCE- NON-TRAINING	442	8.0%
SPECIAL AGENCY MISSION	328	6.0%
TRAINING ATTENDANCE	105	1.9%
OTHER TRAVEL	81	1.5%
SPECIAL MISSION TRAVEL	60	1.1%
SITE VISIT	21	0.4%
EMERGENCY - PERSONAL	18	0.3%
CONFERENCE ATTENDANCE	12	0.2%
Other values (2)	9	0.2%
(Missing)	166	3.0%

Max length	24
Mean length	17.57719585
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

TripType
Categorical

Distinct count	8
Unique (%)	0.1%
Missing (%)	3.0%
Missing (n)	166

Temporary Duty Travel (Routine)	5286
Invitational Travel	12
Dependent Invitational Travel	10
Other values (4)	25
(Missing)	166

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Temporary Duty Travel (Routine)	5286	96.1%
Invitational Travel	12	0.2%
Dependent Invitational Travel	10	0.2%
Dependent Invitational Travel - Transportation Expenses Only	9	0.2%
AA-ROUTINE TDY/TAD	9	0.2%
Government Funded Leave	6	0.1%
Invitational Travel - Transportation Expenses Only	1	< 0.1%
(Missing)	166	3.0%

Max length	60
Mean length	30.1458447
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Underpayments(Credits)*
Numeric

Distinct count	57
Unique (%)	1.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.961745772
Minimum	0
Maximum	3428.7
Zeros (%)	98.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	3428.7
Range	3428.7
Interquartile range	0

Descriptive statistics

Standard deviation	55.51183748
Coef of variation	28.29716178
Kurtosis	2949.234936
Mean	1.961745772
MAD	3.873183414
Skewness	51.72512377
Sum	10787.64
Variance	3081.564101
Memory size	43.1 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 4.0000e+01 1.7859e+02 4.9193e+02 3.4287e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	5428	98.7%
8.35	5	0.1%
30.5	4	0.1%
28	3	0.1%
33	2	< 0.1%
46	2	< 0.1%
38	2	< 0.1%
13.75	2	< 0.1%
27.5	2	< 0.1%
10	2	< 0.1%
Other values (47)	47	0.9%

Minimum 5 values

Value	Count	Frequency (%)
0	5428	98.7%
1	1	< 0.1%
3.16	1	< 0.1%
6.36	1	< 0.1%
8.35	5	0.1%

Maximum 5 values

Value	Count	Frequency (%)
3428.7	1	< 0.1%
1998.43	1	< 0.1%
584.5	1	< 0.1%
399.36	1	< 0.1%
384.79	1	< 0.1%

Underpayments_(Credits)*
Highly correlated

This variable is highly correlated with Underpayments(Credits)* and should be ignored for analysis

Correlation	1

First rows

	Actuals(Y/N)	AdvanceReject(Y/N)	AmountClaim	AOEmailAddress	AutoKey	AwaitingStatus	CancelledDate	Changes_Needed_(Y/N)	Comments	ConstructiveTravelFlag	Corrected_Date	CurrentStatus	CurrentVersionCompletedDate	DateofCurrentStatus	DCSSuborganization	DepartureDate	df_index	Directorate	DocumentCreateDate	DocumentName	DocumentType	DTAIDEmailAddress	Error_Category	ExpensesbyLOA	FinancialReject(Y/N)	ForeignTravelFlag	FullName	ImproperPaymentCorrections	ImproperPayments	IncludesSPP(Y/N)	InputError	LastAOApprovedDate	LOA10by20	LOALabel	Location/Destination(firstonly)	Month_End	Month_Rank	MultipleLOAs(Y/N)	Non-contractFareFlag	Organization/Suborganization	Overpayments(Debts)*	Overpayments_(Debts)*	PNRRecordLocator(allshown)	Reference	Regulation_Unauthorized	ReturnDate	Reviewed_Record	ReviewedVouchers	SDN(representativeSDNfordoctype)	Sent_Date	SignedDate	SpecialCircumstancesTripType	SPPReject(Y/N)	SSN	T-EnteredFlag	TANum	TotalCP-C/CR-CAmount	TotalCP/CRAmount	TotalDaysTDY	TotalInputError	TotalRegulationUnauthorized	TotalReimbursableExpenses	TotalTripExpenses	Travel_Location	TravelerEmailAddress	TravelerFirstName	TravelerLastName	TripDescription	TripPurpose	TripType
0	N	N	5999.20	michael.w.muskopf.civ@mail.mil	69710.0	NaN	NaN	NaN	NaN	N	NaN	ARCHIVE IMAGE ACCEPT	5/5/20	5/6/20	NaN	1/12/20	0	TCAQ	5/5/20	CLMAXWELLAFBA011220_V01-01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	5999.20	N	N	CHAD LINDAUER	0.0	0.0	N	0.0	5/5/20	387700^57^^0^3400^^30^^64^ET^1L3L24^03^^^^^40915^^^387700^^^84751F^^^^^	20 1L3L24	MAXWELL AFB,AL	5/31/20	1.0	N	N	DJ60TCAQ	0.00	0.00	NaN	NaN	0.0	2/27/20	0.0	0.0	2DMMRK TD	NaN	5/5/20	NaN	N	*****3308	N	2DMMRK	0.0	0.0	47.0	0.0	0.0	5999.20	5999.20	MAXWELL AFB,AL	chad.s.lindauer.civ@mail.mil	CHAD	LINDAUER	TLN 9S3T000017Course Title: SQUADRON OFFICER SCHOOLCourse #: MSOS 001 CLASSNumber: 2020BCSD: 13 JAN 2020 - CGD: 27 FEB 2020Location: MAXWELL AFB	TRAINING	Temporary Duty Travel (Routine)
1	N	N	0.00	mary.b.gaffney.civ@mail.mil	69711.0	NaN	NaN	No	Okay	N	NaN	ARCHIVE ACCEPTED	5/14/20	5/15/20	NaN	3/23/20	2	TCAQ	3/12/20	TTCOLUMBUSOH032320_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	0.00	N	N	TAMARA THOUVENOT	0.0	0.0	N	0.0	5/14/20	387700^97^^X^4930^FD50^6F^0^70^AB^G04N70^^_12400^^^^40924^^^387700^^^48090D^^^^^	20 TCAQ MSPT	COLUMBUS,OH	5/31/20	1.0	N	N	DJ60TCAQ	0.00	0.00	NaN	NaN	0.0	3/24/20	1.0	1.0	2E56SM TD	NaN	5/14/20	NaN	N	*****4081	N	2E56SM	0.0	0.0	2.0	0.0	0.0	0.00	0.00	COLUMBUS,OH	tamara.d.thouvenot.civ@mail.mil	TAMARA	THOUVENOT	DLA Land and Maritime Guest SpeakerPNR Locator:N3D8YZ	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
2	N	N	254.51	brian.l.paul2.civ@mail.mil	69712.0	NaN	NaN	No	Okay	N	NaN	REJECT	5/15/20	5/18/20	NaN	9/12/19	3	TCCC	4/23/20	ABSTLOUISMO091219_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	787.36	Y	N	ALAN BECKENSTEIN	0.0	0.0	N	0.0	5/15/20	387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	19 CMDSEC MSPT	ST. LOUIS,MO	5/31/20	1.0	N	N	DJ60TCCC	0.00	0.00	4N42B2	NaN	0.0	9/13/19	1.0	1.0	2CS1JU TD	NaN	5/15/20	NaN	N	*****6524	Y	2CS1JU	524.5	0.0	2.0	0.0	0.0	254.51	787.36	ST. LOUIS,MO	kendall.e.martin2.civ@mail.mil	Alan	Beckenstein	PNR Locator:4N42B2	TRAINING	Invitational Travel
3	N	N	135.00	richard.h.espinosa.mil@mail.mil	69713.0	NaN	NaN	NaN	NaN	N	NaN	ARCHIVE IMAGE ACCEPT	5/15/20	5/18/20	NaN	10/10/19	4	TCCC	5/13/20	DM101019_L01.4-01	LVCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	135.00	N	N	DEE MEWBOURNE	0.0	0.0	N	0.0	5/15/20	387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	20 CMDSEC MSPT	NaN	5/31/20	1.0	N	N	DJ60TCCC	0.00	0.00	NaN	NDTA Fall Meeting	0.0	10/10/19	0.0	0.0	2D0XUV TD	NaN	5/13/20	NaN	N	*****6477	N	2D0XUV	0.0	0.0	1.0	0.0	0.0	135.00	135.00	NaN	kayla.m.georgiafandis.mil@mail.mil	DEE	MEWBOURNE	NaN	NaN	NaN
4	N	N	8.35	richard.h.espinosa.mil@mail.mil	69714.0	NaN	NaN	NaN	NaN	N	NaN	ARCHIVE IMAGE ACCEPT	5/11/20	5/12/20	NaN	12/11/19	5	TCCC	5/7/20	DMWASHINGTOND121119_V02-01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	8.35	N	N	DEE MEWBOURNE	0.0	0.0	N	0.0	5/11/20	387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	20 CMDSEC MSPT	WASHINGTON,DC	5/31/20	1.0	N	N	DJ60TCCC	0.00	0.00	74FPOO	NaN	0.0	12/12/19	0.0	0.0	2DGYP1 TD	NaN	5/11/20	NaN	N	*****6477	N	2DGYP1	0.0	0.0	2.0	0.0	0.0	8.35	8.35	WASHINGTON,DC	kayla.m.georgiafandis.mil@mail.mil	DEE	MEWBOURNE	Attending NDTA Holiday Reception and Board of Directors followed by 3 days of personal leavePNR Locator:74FPOO	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5	N	N	16.70	richard.h.espinosa.mil@mail.mil	69715.0	NaN	NaN	No	Okay	N	NaN	ARCHIVE IMAGE ACCEPT	5/15/20	5/19/20	NaN	3/17/20	6	TCCC	3/13/20	KTSEATTLEWA031320_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	16.70	N	N	KHRISTIAN THOMPSON	0.0	0.0	N	0.0	5/15/20	387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^	20 CMDSEC MSPT	WASHINGTON NAVAL DISTRICT,DC	5/31/20	1.0	N	N	DJ60TCCC	0.00	0.00	NaN	NaN	0.0	3/18/20	1.0	1.0	2EGVDH TD	NaN	5/13/20	NaN	N	*****0105	N	2EGVDH	0.0	0.0	2.0	0.0	0.0	16.70	16.70	WASHINGTON NAVAL DISTRICT,DC	khristian.b.thompson.mil@mail.mil	KHRISTIAN	THOMPSON	Conduct Advance Protective Security Operations in support of a TDY of the CDRUSTRANSCOMPNR Locator:73F24S PNR Locator:L3FEFL	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
6	N	N	113.82	DEON.C.EVANS2.MIL@MAIL.MIL	69716.0	NaN	NaN	Yes	Traveler claimed the mileage from his home to SIU Edwardsville was 66 miles. According to Google it is 32.6. When claiming local mileage you can only claim the mileage above what your daily commute to the Duty Station. His daily commute is 6.1 miles, he entered it as 33 miles. 66-33 = 33 but it should have been 33 - 6 = 27. Traveler was over paid 12 miles a day for a total of $20.64. Please correct mileage numbers.	N	NaN	ARCHIVE ACCEPTED	5/21/20	5/22/20	NaN	3/10/20	7	TCJ1	3/13/20	MR031320_L01	LVCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	113.82	N	N	MITCHELL ROBINSON	9999.0	1.0	N	1.0	5/21/20	387700^97^^X^4930^FD50^6F^0^70^AB^G041D0^^_12400^^^^40924^^^387700^^^48090D^^^^^	20 J1 MSPT	NaN	5/31/20	1.0	N	N	DJ60TCJ1	20.64	20.64	NaN	NaN	1.0	3/12/20	1.0	1.0	2FELUP TD	NaN	3/16/20	NaN	N	*****2723	N	2FELUP	0.0	0.0	3.0	1.0	1.0	113.82	113.82	NaN	mitchell.j.robinson6.civ@mail.mil	MITCHELL	ROBINSON	NaN	NaN	NaN
7	N	N	4010.33	donald.d.johnson70.mil@mail.mil	69717.0	NaN	NaN	Yes	Traveler claimed a Roadside Assistance protection fee he was charged on his rental receipt, which is not an authorized reimbursement. This service is included in the GARS fee he was charged. Rental car claim needs to be reduced by $118.83. Traveler should contact Enterprise and see if he can get them to remove the charge and provide him a credit.	N	NaN	ARCHIVE IMAGE ACCEPT	5/26/20	5/27/20	NaN	5/3/20	11	TCJ1	5/21/20	WJSANANTONIOT050320_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	4010.33	N	N	WISTARIA JOSEPH	9999.0	1.0	N	0.0	5/26/20	387700^57^^0^3400^^30^^15^4A^BKOPB1^04^^^^^40924^^^387700^^^91212F^^^^^	20 3AFELM	SAN ANTONIO,TX	5/31/20	1.0	Y	N	DJ60TCJ1	118.83	118.83	3NL75D	NaN	1.0	5/20/20	1.0	1.0	2F41TY TD	NaN	5/24/20	NaN	N	*****6411	N	2F41TY	0.0	659.2	18.0	0.0	1.0	4010.33	4010.33	SAN ANTONIO,TX	wistaria.j.joseph.mil@mail.mil	WISTARIA	JOSEPH	PNR Locator:3NL75D	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
8	N	N	4010.33	donald.d.johnson70.mil@mail.mil	69718.0	NaN	NaN	NaN	NaN	N	NaN	ARCHIVE IMAGE ACCEPT	5/26/20	5/27/20	NaN	5/3/20	14	TCJ1	5/21/20	WJSANANTONIOT050320_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	0.00	N	N	WISTARIA JOSEPH	0.0	0.0	N	0.0	5/26/20	387700^97^^X^4930^FD50^6F^0^70^AB^G041D0^^_12400^^^^40924^^^387700^^^48090D^^^^^	20 J1 MSPT	SAN ANTONIO,TX	5/31/20	1.0	Y	N	DJ60TCJ1	0.00	0.00	3NL75D	NaN	0.0	5/20/20	0.0	0.0	2F41TY TD	NaN	5/24/20	NaN	N	*****6411	N	2F41TY	0.0	659.2	18.0	0.0	0.0	4010.33	4010.33	SAN ANTONIO,TX	wistaria.j.joseph.mil@mail.mil	WISTARIA	JOSEPH	PNR Locator:3NL75D	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
9	Y	N	7700.30	peggy.a.beahm.civ@mail.mil	69719.0	NaN	NaN	No	Okay	Y	NaN	ARCHIVE IMAGE ACCEPT	5/20/20	5/21/20	NaN	3/16/20	15	TCJ3	5/19/20	ARLITTLEROCKA031620_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	7700.30	N	N	ANDREW RODDAN	0.0	0.0	N	0.0	5/20/20	387700^57^^0^3400^^30^^65^MD^330000^02^^^^^40924^^^387700^^^41132F^^^^^	20 GRP NON FLY1	LITTLE ROCK AFB,AR	5/31/20	1.0	N	N	DJ60TCJ3	0.00	0.00	NaN	NaN	0.0	5/13/20	1.0	1.0	2EARVV TD	NaN	5/20/20	NaN	N	*****1749	N	2EARVV	0.0	0.0	59.0	0.0	0.0	7700.30	7700.30	LITTLE ROCK AFB,AR	andrew.l.roddan.mil@mail.mil	ANDREW	RODDAN	C-130J RequalCourse PXC2020X14 TLN: OD3T000003	TRAINING	Temporary Duty Travel (Routine)

Last rows

	Actuals(Y/N)	AdvanceReject(Y/N)	AmountClaim	AOEmailAddress	AutoKey	AwaitingStatus	CancelledDate	Changes_Needed_(Y/N)	Comments	ConstructiveTravelFlag	Corrected_Date	CorrectedVouchers	CurrentStatus	CurrentVersionCompletedDate	DateofCurrentStatus	DCSSuborganization	DepartureDate	df_index	Directorate	DocumentCreateDate	DocumentName	DocumentType	DTAIDEmailAddress	Error_Category	ExpensesbyLOA	FinancialReject(Y/N)	ForeignTravelFlag	FullName	ImproperPaymentCorrections	ImproperPayments	IncludesSPP(Y/N)	LastAOApprovedDate	LOA10by20	LOALabel	Location/Destination(firstonly)	Month_End	Month_Rank	MultipleLOAs(Y/N)	Non-contractFareFlag	Organization/Suborganization	Overpayments(Debts)*	Overpayments_(Debts)*	PNRRecordLocator(allshown)	Receiptdoesnotmatchclaim	Reference	ReturnDate	Reviewed_Record	ReviewedVouchers	SDN(representativeSDNfordoctype)	Sent_Date	SignedDate	SpecialCircumstancesTripType	SPPReject(Y/N)	SSN	T-EnteredFlag	TANum	TotalCP-C/CR-CAmount	TotalCP/CRAmount	TotalDaysTDY	TotalReceiptDoesNotMatchClaim	TotalReimbursableExpenses	TotalTripExpenses	Travel_Location	TravelerEmailAddress	TravelerFirstName	TravelerLastName	TripDescription	TripPurpose	TripType
5489	N	N	6164.12	jonathan.gilbert@jte.osd.mil	63055.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/6/19	6/8/19	NaN	5/6/19	7123	TCSG	5/24/19	MHFRANKFURTAM050519_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	6164.12	N	Y	MICHELE HOLDERNESS	0.0	0.0	N	6/6/19	012148^097^^0460^^20182019^^^^0600030605814OTE^10156^340508^^16723446^10807^^3131^^^	18 DOTE JIMTM	FRANKFURT AM MAIN,DEU	6/30/19	12.0	N	Y	DJ60TCSG	0.0	0.0	2JCV36	0.0	NaN	5/17/19	0.0	0.0	2AU999	NaN	6/5/19	NaN	N	*****9116	N	2AU999	0.0	2153.14	12.0	0.0	6164.12	6164.12	FRANKFURT AM MAIN,DEU	michele.j.holderness.mil@mail.mil	MICHELE	HOLDERNESS	JIMTM TPMRC Close downPNR Locator:2JCV36	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5490	Y	N	786.25	jonathan.gilbert@jte.osd.mil	63056.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/11/19	6/13/19	NaN	5/28/19	7124	TCSG	6/4/19	MHSUFFOLKVA052819_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	786.25	N	N	MICHELE HOLDERNESS	0.0	0.0	N	6/11/19	012148^097^^0460^^20182019^^^^0600030605814OTE^10156^340508^^16723446^10807^^3131^^^	18 DOTE JIMTM	SUFFOLK,VA	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	3WJ9WP	0.0	NaN	5/30/19	0.0	0.0	2B81T0	NaN	6/10/19	NaN	N	*****9116	N	2B81T0	0.0	354.50	3.0	0.0	786.25	786.25	SUFFOLK,VA	michele.j.holderness.mil@mail.mil	MICHELE	HOLDERNESS	JI-MTM DRB BoardPNR Locator:3WJ9WP	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5491	N	N	4706.63	patrick.a.martinez4.mil@mail.mil	63057.0	NaN	NaN	NaN	NaN	N	NaN	0.0	POS ACK RECEIVED	6/19/19	6/24/19	NaN	5/12/19	7125	TCSG	6/18/19	MSBANGKOKTHA051119_V01-01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	4512.39	N	Y	MARCUS SNYDER	0.0	0.0	N	6/19/19	056521^17^19^19^1804^11CQ^2110^07411^^056521^2D^^N00038^J4^E2^VG^1A10^^^^6412^8522^AA^^^^^^	19 APRI 36412	BANGKOK,THA	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	NDONZ8	0.0	NaN	5/19/19	0.0	0.0	N0003819TOATKDD	NaN	6/18/19	NaN	N	*****1604	N	2ATKDD	0.0	2688.13	8.0	0.0	4512.39	4512.39	BANGKOK,THA	MARCUS.SNYDER@us.af.mil	MARCUS	SNYDER	Nepal Subject Matter Expert ExchangePNR Locator:NDONZ8	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5492	N	N	1666.60	patrick.a.martinez4.mil@mail.mil	63058.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/25/19	6/26/19	NaN	3/3/19	7126	TCSG	4/30/19	JAWASHINGTOND030419_V04-01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	1666.60	N	N	JOHN ANDRUS	0.0	0.0	N	6/25/19	387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^	19 SG HQ MSPT X	WASHINGTON,DC	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	LRHNDY	0.0	NaN	3/6/19	0.0	0.0	29OX2C TD	NaN	6/25/19	NaN	N	*****5797	N	29OX2C	0.0	349.30	4.0	0.0	1666.60	1666.60	WASHINGTON,DC	john.r.andrus.mil@mail.mil	JOHN	ANDRUS	PNR Locator:LRHNDY	SPEECH OR PRESENTATION	Temporary Duty Travel (Routine)
5493	N	N	1217.93	patrick.a.martinez4.mil@mail.mil	63059.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/25/19	6/27/19	NaN	5/19/19	7127	TCSG	6/3/19	JARANDOLPHAFB051919_V02	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	1217.93	N	N	JOHN ANDRUS	0.0	0.0	N	6/25/19	387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^	19 GPMRC TDY	RANDOLPH AFB,TX	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	LVRIJF	0.0	NaN	5/22/19	0.0	0.0	2B3KF5 TD	NaN	6/25/19	NaN	N	*****5797	N	2B3KF5	0.0	676.00	4.0	0.0	1217.93	1217.93	RANDOLPH AFB,TX	john.r.andrus.mil@mail.mil	JOHN	ANDRUS	Air Force Medical Corps Development TeamPNR Locator:LVRIJF	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5494	N	N	2119.14	patrick.a.martinez4.mil@mail.mil	63060.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/25/19	6/27/19	NaN	5/26/19	7128	TCSG	6/3/19	JAKELLEYBARRA052719_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	2119.14	N	Y	JOHN ANDRUS	0.0	0.0	N	6/25/19	387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^	19 SG HQ MSPT X	KELLEY BARRACKS (STUTTGART),DEU	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	2NSZON	0.0	NaN	5/31/19	0.0	0.0	2B83TM TD	NaN	6/25/19	NaN	N	*****5797	N	2B83TM	0.0	1135.63	6.0	0.0	2119.14	2119.14	KELLEY BARRACKS (STUTTGART),DEU	john.r.andrus.mil@mail.mil	JOHN	ANDRUS	COMMAND SURGEON SYNCHRONIZATION CONFERENCEPNR Locator:2NSZON	CONFERENCE- NON-TRAINING	Temporary Duty Travel (Routine)
5495	N	N	1304.40	Kerry.L.Mosley.MIL@MAIL.mil	63061.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/10/19	6/12/19	NaN	6/3/19	7129	TCSG	6/7/19	SBFTBUCHANANI060319_V02	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	1304.40	N	N	STACEY BRANCH	0.0	0.0	N	6/10/19	387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^	19 GPMRC TDY	FT. BUCHANAN [INCL GSA SVC CTR GUAYNABO],PR	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	3OC9FA	0.0	NaN	6/6/19	0.0	0.0	2ASROA TD	NaN	6/7/19	NaN	N	*****1074	N	2ASROA	0.0	496.40	4.0	0.0	1304.40	1304.40	FT. BUCHANAN [INCL GSA SVC CTR GUAYNABO],PR	STACEY.L.BRANCH.mil@mail.mil	STACEY	BRANCH	2019 TRICARE Latin America and Canada Senior Leaders and Stakeholders Engagement ForumPNR Locator:3OC9FA	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5496	Y	N	1493.42	patrick.a.martinez4.mil@mail.mil	63062.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/5/19	6/8/19	NaN	5/27/19	7130	TCSG	6/4/19	SKKELLEYBARRA052719_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	1493.42	N	Y	SYLVIA KIM	0.0	0.0	N	6/5/19	387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^	19 GPMRC TDY	KELLEY BARRACKS (STUTTGART),DEU	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	NaN	0.0	NaN	5/31/19	0.0	0.0	2B7MOC TD	NaN	6/4/19	NaN	N	*****1556	N	2B7MOC	0.0	0.00	5.0	0.0	1493.42	1493.42	KELLEY BARRACKS (STUTTGART),DEU	sylvia.kim@us.af.mil	SYLVIA	KIM	AFRICOM Surgeon General Synchronization Conference 2019	CONFERENCE- NON-TRAINING	Temporary Duty Travel (Routine)
5497	N	N	2582.96	patrick.a.martinez4.mil@mail.mil	63063.0	NaN	NaN	Yes	Traveler claimed lodging 2X, once on the per diem screen as it should be and once on the Expense screen. Over paid $644.	N	8/13/19	1.0	ARCHIVE IMAGE ACCEPT	6/21/19	6/25/19	NaN	5/19/19	7131	TCSG	6/17/19	SSNEWORLEANSL051919_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	2582.96	N	N	STEVEN SAVOY	28.0	1.0	N	6/21/19	387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^	19 SG HQ MSPT X	NEW ORLEANS,LA	6/30/19	12.0	N	N	DJ60TCSG	644.0	644.0	NaN	1.0	NaN	5/31/19	1.0	1.0	2B0PAL TD	7/16/19	6/20/19	NaN	N	*****7139	N	2B0PAL	0.0	0.00	13.0	1.0	2582.96	2582.96	NEW ORLEANS,LA	steven.r.savoy3.fm@mail.mil	Steven	Savoy	Site visits for PM for DSCA & State Gen Pop exercise	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)
5498	Y	N	1263.76	patrick.a.martinez4.mil@mail.mil	63064.0	NaN	NaN	NaN	NaN	N	NaN	0.0	ARCHIVE IMAGE ACCEPT	6/21/19	6/24/19	NaN	6/10/19	7132	TCSG	6/18/19	SSSTCROIXVI061019_V01	VCH	transcom.scott.tcj8.mbx.dts-rejects@mail.mil	NaN	3221.11	N	N	STEVEN SAVOY	0.0	0.0	N	6/21/19	387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^	19 SG HQ MSPT X	ST. CROIX,VI	6/30/19	12.0	N	N	DJ60TCSG	0.0	0.0	MC8X58	0.0	NaN	6/13/19	0.0	0.0	2BH62X TD	NaN	6/20/19	NaN	N	*****7139	N	2BH62X	1949.0	0.00	4.0	0.0	1263.76	3221.11	ST. CROIX,VI	steven.r.savoy3.fm@mail.mil	Steven	Savoy	Site visits for DSCA support for 2019 Hurricane SeasonPNR Locator:MC8X58	MISSION - OPERATIONAL	Temporary Duty Travel (Routine)

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows